MS Excel Question. 1
1. What is extension of files created in
MS-Excel 97-2003
(a) .xlx
(b) .msx
(c) .Dot
(d) .xls
2. What is extension of files created in
MS-Excel 2007-2015
(a) Txt
(b) XLS
(c) XLSX
(d) RTF
​
3. MS-Office is -
(a) Application Software
(b) System Software
(c) Operating System
(d) All of above
​
4. Which menu option in MS Excel has the
option to "Sort the Data"
(a) Review
(b) Data
(c) Formula
(d) Insert
​
5. Which is the correct formula for SUM
Function in MS Excel.
(a) /SUM(A1+A5)
(b) =SUM(A1-A5)
(c) =SUM(A1:A5)
(d) +SUM(A1:A5)
​
6. What is the use of VLOOKUP function in MS
Excel -
(a) to get the max value
(b) to copy a row
(c) to find things in a table
(d) None of these
​
7. Which button in MSExcel to calculate the
sum of number
(a) AutoSum
(b) Fill
(c) Insert
(d) Merge
​
8. What is the Shortcut key for "Current
Date" in Excel
(a) Ctrl + C
(b) Ctrl + D
(c) Alt + ;
(d) Ctrl + ;
​
9. What is the Shortcut key for "Current
Time" in Excel
(a) Ctrl + Shift + :
(b) Ctrl + T
(c) Ctrl + D
(d) Ctrl + ;
10. What is the shortcut to insert comment in
MS Excel
(a) Ctrl + F6
(b) Alt + F8
(c) Shift + F9
(d) Shift + F2
​
11. Which function in MS Excel counts the
number of characters in a Cell
(a) Len ( )
(b) Length ( )
(c) Count ( )
(d) LNG ( )
Answer – (d) Len ( )
12. What of these is a shortcut to add a
border to the selected cell in MS Excel
(a) Ctrl + T
(b) Ctrl + B
(c) Shift + B
(d) Ctrl + Shift + &
​
13. What is the shortcut key of Hyperlink in
Excel
(a) Ctrl + H
(b) Ctrl + K
(c) Alt + S
(d) Alt + K
​
14. What is the Shortcut key for select
Complete Row
(a) Shift + Space
(b) Ctrl + Space
(c) Alt + Space
(d) None of these
​
15. What is the Shortcut key for select
Complete Column
(a) Shift + Space
(b) Ctrl + Space
(c) Alt + Space
(d) None of these
​
16. What is the intersection of a column
and row on worksheet called ?
(a) Row
(b) Column
(c) Cell
(d) Address
​
17. MS Excel is a -
(a) Word Processing Software
(b) Spreadsheet Program
(c) Presentation Program
(d) None of these
​
18. The Software which contains rows and
column is called -
(a) Word Processing
(b) Database
(c) Spreadsheet
(d) None of these
​
19. Formulas in Excel Start with -
(a) +
(b) #
(c) %
(d) =
​
20. To return the remainder after a no. is
divided by a divisor in Excel
(a) Round ( )
(b) Mod ( )
(c) Fact ( )
(d) None of these
​
21. Hyperlinks can be
(a) Text
(b) Drawing
(c) Picture
(d) All of the above
​
22. NOT, AND, OR and XOR are -
(a) Relational Operator
(b) Logical Operators
(c) Arithmetic Operators
(d) None of these
​
23. The shortcut key to hide entire column
(a) Ctrl + H
(b) Ctrl + 0
(c) Ctrl + -
(d) None of these
​
24. Which of the following is correct -
(a) = power (2^3)
(b) = power (2*3)
(c) = power (2,3)
(d) None of these
​
25. What is the shortcut key to insert a new
comment in a cell ?
(a) ALT + F2
(b) Ctrl + F2
(c) Shift + F2
(d) None of these
​
26. What is the shortcut key to insert new
sheet in current workbook ?
(a) Shift + F11
(b) Ctrl + F11
(c) Atl + F11
(d) None of these
​
27. How many sheets are there, by default,
when we create a new excel file ?
(a) 1
(b) 2
(c) 3
(d) 4
​
28. Which sign display when formula error in
MS Excel
(a) $
(b) *
(c) #
(d) \
​
29. What is the Shortcut Key of
"AutoSum"
(a) Ctrl + =
(b) Alt + =
(c) Ctrl + A
(d) Shift + =
​
30. What is the Shortcut Key for Insert (Row,
Column)
(a) Ctrl + +
(b) Ctrl + C
(c) Ctrl + R
(d) Ctrl + A
​
31. What is the Shortcut Key for Delete (Row,
Column)
(a) Ctrl + D
(b) Ctrl + R
(c) Ctrl + C
(d) Ctrl + -
​
32. The Shortcut Key for Hide Rows
(a) Ctrl + 9
(b) Ctrl + S
(c) Ctrl + H
(d) Ctrl + R
​
33. The Shortcut Key for Hide Columns
(a) Ctrl + H
(b) Ctrl + C
(c) Ctrl + 9
(d) Ctrl + 0
​
34. The Shortcut Key for Unhide Rows
(a) Ctrl + Shift + (
(b) Ctrl + U
(c) Ctrl + H
(d) Ctrl + R
​
35. The Shortcut Key for Unhide Columns
(a) Ctrl + H
(b) Ctrl + K
(c) Ctrl + Shift + )
(d) Ctrl + Z
Post a Comment